from __future__ import print_function

import psycopg2
import psycopg2.extras
from flask import Flask

table_sql = """
CREATE TABLE points_of_interest
        (
          gid SERIAL NOT NULL,
          name CHARACTER VARYING(240),
          the_geom GEOMETRY,
          CONSTRAINT points_of_interest_pkey PRIMARY KEY (gid),
          CONSTRAINT enforce_dims_geom CHECK (st_ndims(the_geom) = 2),
          CONSTRAINT enforce_geotype_geom CHECK (geometrytype(the_geom) = 'POINT'::TEXT OR the_geom IS NULL),
          CONSTRAINT enforce_srid_geom CHECK (st_srid(the_geom) = 4326)
        )
        WITH (
          OIDS=FALSE
        );
        CREATE INDEX points_of_interest_geom_gist
          ON points_of_interest
          USING GIST
          (the_geom);
          """


def bootstrap():
    app = Flask(__name__)

    pg_host = "127.0.0.1"
    pg_port = 5432
    pg_name = "crowdsourcingDB"
    pg_username = "postgres"
    pg_password = "postgresql"

    conn = psycopg2.connect(host=pg_host, port=pg_port, database=pg_name, user=pg_username, password=pg_password)
    cur = conn.cursor()
    try:
        # cur.execute("CREATE EXTENSION postgis;")
        cur.execute(table_sql)
        for d in insert_data:
            cur.execute("INSERT INTO points_of_interest (name, the_geom) VALUES (" + d + ")")
        conn.commit()
    finally:
        cur.close()
        conn.close()
        print("Finished bootstrapping")


insert_data = [
    "'Abraham Lincoln Birthplace National Historical Park', ST_GeomFromText('POINT(-85.7302 37.5332)', 4326)",
    "'Abraham Lincoln National Cemetery', ST_GeomFromText('POINT(-88.12595 41.3896)', 4326)",
    "'Acadia National Park', ST_GeomFromText('POINT(-68.04902 44.454)', 4326)",
    "'Adams National Historical Park', ST_GeomFromText('POINT(-71.01119 42.25639)', 4326)",
    "'Admiralty Island National Monument', ST_GeomFromText('POINT(-134.16105 57.61806)', 4326)",
    "'African American Civil War Memorial', ST_GeomFromText('POINT(-77.02569 38.91639)', 4326)",
    "'African Burial Ground National Monument', ST_GeomFromText('POINT(-73.99364 40.71367)', 4326)",
    "'Agate Fossil Beds National Monument', ST_GeomFromText('POINT(-103.75492 42.42428)', 4326)",
    "'Agua Fria National Monument', ST_GeomFromText('POINT(-112.07633 34.15417)', 4326)",
    "'AIDS Memorial Grove', ST_GeomFromText('POINT(-122.46122 37.77)', 4326)",
    "'Ala Kahakai National Historic Trail', ST_GeomFromText('POINT(-155.68106 18.91111)', 4326)",
    "'Alagnak River', ST_GeomFromText('POINT(-156.79582 59.01063)', 4326)",
    "'Aleutian World War II National Historic Area', ST_GeomFromText('POINT(-166.52692 53.88889)', 4326)",
    "'Alibates Flint Quarries National Monument', ST_GeomFromText('POINT(-101.66722 35.57139)', 4326)",
    "'Allegheny Portage Railroad', ST_GeomFromText('POINT(-78.5401 40.45417)', 4326)",
    "'American Memorial Park', ST_GeomFromText('POINT(145.71691 15.2181)', 4326)",
    "'Amistad National Recreation Area', ST_GeomFromText('POINT(-101.04972 29.43667)', 4326)",
    "'Anacostia Park', ST_GeomFromText('POINT(-76.89998 38.8)', 4326)",
    "'Andersonville National Cemetery', ST_GeomFromText('POINT(-84.13093 32.20358)', 4326)",
    "'Andersonville National Historic Site', ST_GeomFromText('POINT(-84.12686 32.19759)', 4326)",
    "'Andrew Johnson National Cemetery', ST_GeomFromText('POINT(-82.83763 36.15527)', 4326)",
    "'Andrew Johnson National Historic Site', ST_GeomFromText('POINT(-82.83482 36.15833)', 4326)",
    "'Aniakchak National Monument and Preserve', ST_GeomFromText('POINT(-158.14972 56.9)', 4326)",
    "'Antietam National Battlefield', ST_GeomFromText('POINT(-77.73945 39.4803)', 4326)",
    "'Antietam National Cemetery', ST_GeomFromText('POINT(-77.73904 39.47914)', 4326)",
    "'Apostle Islands National Lakeshore', ST_GeomFromText('POINT(-90.66402 46.96528)', 4326)",
    "'Appomattox Court House National Historical Park', ST_GeomFromText('POINT(-78.80083 37.37845)', 4326)",
    "'Arches National Park', ST_GeomFromText('POINT(-109.56462 38.77)', 4326)",
    "'Arkansas Post National Memorial', ST_GeomFromText('POINT(-91.34347 34.02361)', 4326)",
    "'Arlington House The Robert E. Lee Memorial', ST_GeomFromText('POINT(-77.07389 38.88275)', 4326)",
    "'Arlington National Cemetery', ST_GeomFromText('POINT(-77.07122 38.87657)', 4326)",
    "'Assateague Island National Seashore', ST_GeomFromText('POINT(-75.20818 38.08332)', 4326)",
    "'Aulavik National Park', ST_GeomFromText('POINT(-119.74092 74.02249)', 4326)",
    "'Auyuittuq National Park', ST_GeomFromText('POINT(-65.01638 67.88333)', 4326)",
    "'Aztec Ruins National Monument', ST_GeomFromText('POINT(-107.99782 36.83583)', 4326)",
    "'Badlands National Park', ST_GeomFromText('POINT(-102.43392 43.6504)', 4326)",
    "'Bandelier National Monument', ST_GeomFromText('POINT(-106.32082 35.77888)', 4326)",
    "'Banff National Park', ST_GeomFromText('POINT(-115.54962 51.16666)', 4326)",
    "'Battleground National Cemetery', ST_GeomFromText('POINT(-73.96286 40.81333)', 4326)",
    "'Benjamin Franklin National Memorial', ST_GeomFromText('POINT(-75.17286 39.95832)', 4326)",
    "'Bent''s Old Fort National Historic Site', ST_GeomFromText('POINT(-103.42502 38.04045)', 4326)",
    "'Bering Land Bridge National Preserve', ST_GeomFromText('POINT(-164.80842 66.05595)', 4326)",
    "'Big Bend National Park', ST_GeomFromText('POINT(-103.06042 29.81874)', 4326)",
    "'Big Cypress National Preserve', ST_GeomFromText('POINT(-81.0337 25.85889)', 4326)",
    "'Big Hole National Battlefield', ST_GeomFromText('POINT(-113.64332 45.6375)', 4326)",
    "'Big South Fork National River and Recreation Area', ST_GeomFromText('POINT(-84.69835 36.4865)', 4326)",
    "'Big Thicket National Preserve', ST_GeomFromText('POINT(-94.41082 30.27567)', 4326)",
    "'Bighorn Canyon National Recreation Area', ST_GeomFromText('POINT(-108.13032 45.19444)', 4326)",
    "'Biscayne National Park', ST_GeomFromText('POINT(-80.26162 25.442)', 4326)",
    "'Black Canyon of the Gunnison National Park', ST_GeomFromText('POINT(-107.72792 38.58491)', 4326)",
    "'Blue Ridge Parkway', ST_GeomFromText('POINT(-80.93578 36.51861)', 4326)",
    "'Bluestone National Scenic River', ST_GeomFromText('POINT(-80.99901 37.54167)', 4326)",
    "'Booker T. Washington National Monument', ST_GeomFromText('POINT(-79.76564 37.12333)', 4326)",
    "'Boston African American National Historic Site', ST_GeomFromText('POINT(-71.06454 42.36)', 4326)",
    "'Boston Harbor Islands National Recreation Area', ST_GeomFromText('POINT(-70.94565 42.31861)', 4326)",
    "'Boston National Historical Park', ST_GeomFromText('POINT(-71.05617 42.36)', 4326)",
    "'Brices Cross Roads National Battlefield Site', ST_GeomFromText('POINT(-88.7284 34.50672)', 4326)",
    "'Brown v. Board of Education National Historic Site', ST_GeomFromText('POINT(-95.67621 39.03806)', 4326)",
    "'Bruce Peninsula National Park', ST_GeomFromText('POINT(-81.61388 45.23888)', 4326)",
    "'Bryce Canyon National Park', ST_GeomFromText('POINT(-112.19632 37.5548)', 4326)",
    "'Buck Island Reef National Monument', ST_GeomFromText('POINT(-64.61897 17.78694)', 4326)",
    "'Buffalo National River', ST_GeomFromText('POINT(-92.42606 36.17806)', 4326)",
    "'Cabrillo National Monument', ST_GeomFromText('POINT(-117.24202 32.67352)', 4326)",
    "'California Coastal National Monument', ST_GeomFromText('POINT(-122.17994 36.89)', 4326)",
    "'Canaveral National Seashore', ST_GeomFromText('POINT(-80.77679 28.7675)', 4326)",
    "'Cane River Creole National Historical Park', ST_GeomFromText('POINT(-93.00343 31.66684)', 4326)",
    "'Canyon de Chelly National Monument', ST_GeomFromText('POINT(-109.46912 36.1336)', 4326)",
    "'Canyonlands National Park', ST_GeomFromText('POINT(-109.88072 38.261)', 4326)",
    "'Canyons of the Ancients National Monument', ST_GeomFromText('POINT(-108.99994 37.37)', 4326)",
    "'Cape Breton Highlands National Park', ST_GeomFromText('POINT(-60.8111 46.81611)', 4326)",
    "'Cape Cod National Seashore', ST_GeomFromText('POINT(-70.20513 42.07389)', 4326)",
    "'Cape Hatteras National Seashore', ST_GeomFromText('POINT(-75.51123 35.30361)', 4326)",
    "'Cape Henry Memorial', ST_GeomFromText('POINT(-76.00819 36.92806)', 4326)",
    "'Cape Krusenstern National Monument', ST_GeomFromText('POINT(-163.50002 67.41333)', 4326)",
    "'Cape Lookout National Seashore', ST_GeomFromText('POINT(-76.53624 34.60528)', 4326)",
    "'Capitol Reef National Park', ST_GeomFromText('POINT(-111.23862 38.27617)', 4326)",
    "'Captain John Smith Chesapeake National Historic Trail', ST_GeomFromText('POINT(-75.99995 38)', 4326)",
    "'Capulin Volcano National Monument', ST_GeomFromText('POINT(-103.96972 36.78222)', 4326)",
    "'Carl Sandburg Home National Historic Site', ST_GeomFromText('POINT(-82.45149 35.26778)', 4326)",
    "'Carlsbad Caverns National Park', ST_GeomFromText('POINT(-104.40902 32.1648)', 4326)",
    "'Carrizo Plain', ST_GeomFromText('POINT(-119.74994 35.16)', 4326)",
    "'Carter G. Woodson Home National Historic Site', ST_GeomFromText('POINT(-77.02399 38.90999)', 4326)",
    "'Casa Grande Ruins National Monument', ST_GeomFromText('POINT(-111.53162 32.99517)', 4326)",
    "'Cascade-Siskiyou National Monument', ST_GeomFromText('POINT(-122.46105 42.07778)', 4326)",
    "'Castillo de San Marcos National Monument', ST_GeomFromText('POINT(-81.31153 29.89775)', 4326)",
    "'Castle Clinton National Monument', ST_GeomFromText('POINT(-74.01674 40.7036)', 4326)",
    "'Catoctin Mountain Park', ST_GeomFromText('POINT(-77.46665 39.64833)', 4326)",
    "'Cedar Breaks National Monument', ST_GeomFromText('POINT(-112.84612 37.64519)', 4326)",
    "'Cedar Creek and Belle Grove National Historical Park', ST_GeomFromText('POINT(-78.30063 39.16749)', 4326)",
    "'Chaco Culture National Historical Park', ST_GeomFromText('POINT(-107.95862 36.05833)', 4326)",
    "'Chalmette National Cemetery', ST_GeomFromText('POINT(-89.98648 29.94417)', 4326)",
    "'Chamizal National Memorial', ST_GeomFromText('POINT(-106.45402 31.76778)', 4326)",
    "'Channel Islands National Park', ST_GeomFromText('POINT(-119.74212 34.0394)', 4326)",
    "'Charles Pinckney National Historic Site', ST_GeomFromText('POINT(-79.82454 32.84611)', 4326)",
    "'Chattahoochee River National Recreation Area', ST_GeomFromText('POINT(-84.32454 33.98722)', 4326)",
    "'Chesapeake and Ohio Canal National Historical Park', ST_GeomFromText('POINT(-77.05744 38.89972)', 4326)",
    "'Chicago Portage National Historic Site', ST_GeomFromText('POINT(-87.80676 41.80556)', 4326)",
    "'Chickamauga and Chattanooga National Military Park', ST_GeomFromText('POINT(-85.25984 34.94)', 4326)",
    "'Chickasaw National Recreation Area', ST_GeomFromText('POINT(-96.97204 34.50056)', 4326)",
    "'Chimney Rock National Historic Site', ST_GeomFromText('POINT(-103.34792 41.70368)', 4326)",
    "'Chiricahua National Monument', ST_GeomFromText('POINT(-109.34802 32.01778)', 4326)",
    "'Christiansted National Historic Site', ST_GeomFromText('POINT(-64.70204 17.74693)', 4326)",
    "'City of Rocks National Reserve', ST_GeomFromText('POINT(-113.70366 42.07727)', 4326)",
    "'Clara Barton National Historic Site', ST_GeomFromText('POINT(-77.14065 38.96694)', 4326)",
    "'Colonial National Historical Park', ST_GeomFromText('POINT(-76.5084 37.21926)', 4326)",
    "'Colonial Parkway', ST_GeomFromText('POINT(-76.71576 37.21557)', 4326)",
    "'Colorado National Monument', ST_GeomFromText('POINT(-108.68582 39.04249)', 4326)",
    "'Congaree National Park', ST_GeomFromText('POINT(-80.78308 33.78333)', 4326)",
    "'Coronado National Memorial', ST_GeomFromText('POINT(-110.25602 31.3455)', 4326)",
    "'Cowpens National Battlefield', ST_GeomFromText('POINT(-81.8179 35.13667)', 4326)",
    "'Crater Lake National Park', ST_GeomFromText('POINT(-122.10872 42.943)', 4326)",
    "'Craters of the Moon National Monument and Preserve', ST_GeomFromText('POINT(-113.51642 43.41667)', 4326)",
    "'Cumberland Gap National Historical Park', ST_GeomFromText('POINT(-83.68703 36.60417)', 4326)",
    "'Cumberland Island National Seashore', ST_GeomFromText('POINT(-81.44985 30.83333)', 4326)",
    "'Curecanti National Recreation Area', ST_GeomFromText('POINT(-107.32672 38.45472)', 4326)",
    "'Custer National Cemetery', ST_GeomFromText('POINT(-107.43165 45.56953)', 4326)",
    "'Cuyahoga Valley National Park', ST_GeomFromText('POINT(-81.55677 41.20906)', 4326)",
    "'David Berger National Memorial', ST_GeomFromText('POINT(-81.49236 41.47472)', 4326)",
    "'Dayton Aviation Heritage National Historical Park', ST_GeomFromText('POINT(-84.0887 39.79472)', 4326)",
    "'De Soto National Memorial', ST_GeomFromText('POINT(-82.64429 27.52389)', 4326)",
    "'Death Valley National Park', ST_GeomFromText('POINT(-117.09872 36.524)', 4326)",
    "'Delaware Water Gap National Recreation Area', ST_GeomFromText('POINT(-75.01726 41.08232)', 4326)",
    "'Delaware Water Gap National Recreation Area', ST_GeomFromText('POINT(-75.00416 41.08996)', 4326)",
    "'Delaware Water Gap National Recreation Area', ST_GeomFromText('POINT(-74.89562 41.14625)', 4326)",
    "'Delaware Water Gap National Recreation Area', ST_GeomFromText('POINT(-74.80594 41.30989)', 4326)",
    "'Delaware Water Gap National Recreation Area Boat Launch', ST_GeomFromText('POINT(-74.98472 41.10718)', 4326)",
    "'Delaware Water Gap NRA Store & Campground', ST_GeomFromText('POINT(-74.87387 41.21144)', 4326)",
    "'Denali National Park', ST_GeomFromText('POINT(-149.98632 63.54357)', 4326)",
    "'Denali National Park and Preserve', ST_GeomFromText('POINT(-150.49972 63.33333)', 4326)",
    "'Devils Postpile National Monument', ST_GeomFromText('POINT(-119.08412 37.62444)', 4326)",
    "'Devils Tower National Monument', ST_GeomFromText('POINT(-104.71502 44.59028)', 4326)",
    "'Dinosaur National Monument', ST_GeomFromText('POINT(-108.98302 40.53333)', 4326)",
    "'Dry Tortugas National Park', ST_GeomFromText('POINT(-81.7859 24.6384)', 4326)",
    "'East Potomac Park', ST_GeomFromText('POINT(-77.0259 38.87)', 4326)",
    "'Ebey''s Landing National Historical Reserve', ST_GeomFromText('POINT(-122.68951 48.21341)', 4326)",
    "'Edgar Allan Poe National Historic Site', ST_GeomFromText('POINT(-75.15011 39.96167)', 4326)",
    "'Effigy Mounds National Monument', ST_GeomFromText('POINT(-91.18537 43.08861)', 4326)",
    "'Eisenhower National Historic Site', ST_GeomFromText('POINT(-77.26316 39.79332)', 4326)",
    "'El Malpais National Monument', ST_GeomFromText('POINT(-107.95752 34.87635)', 4326)",
    "'El Morro National Monument', ST_GeomFromText('POINT(-108.35302 35.03833)', 4326)",
    "'Eleanor Roosevelt National Historic Site', ST_GeomFromText('POINT(-73.93511 41.78582)', 4326)",
    "'Elk Island National Park', ST_GeomFromText('POINT(-112.87042 53.59277)', 4326)",
    "'Ellis Island National Monument', ST_GeomFromText('POINT(-74.03937 40.69956)', 4326)",
    "'Eugene O''Neill National Historic Site', ST_GeomFromText('POINT(-122.02942 37.82444)', 4326)",
    "'Everglades National Park', ST_GeomFromText('POINT(-80.79976 25.36)', 4326)",
    "'Father Marquette National Memorial', ST_GeomFromText('POINT(-84.71708 45.85167)', 4326)",
    "'Federal Hall', ST_GeomFromText('POINT(-74.01014 40.70722)', 4326)",
    "'Fire Island National Seashore', ST_GeomFromText('POINT(-72.98263 40.69639)', 4326)",
    "'First Ladies National Historic Site', ST_GeomFromText('POINT(-81.37511 40.79667)', 4326)",
    "'Flight 93 National Memorial', ST_GeomFromText('POINT(-78.9076 40.05615)', 4326)",
    "'Florissant Fossil Beds National Monument', ST_GeomFromText('POINT(-105.26744 38.91806)', 4326)",
    "'Ford''s Theatre National Historic Site', ST_GeomFromText('POINT(-77.02563 38.89667)', 4326)",
    "'Forillon National Park', ST_GeomFromText('POINT(-64.29027 48.82388)', 4326)",
    "'Fort Bowie National Historic Site', ST_GeomFromText('POINT(-109.43542 32.14611)', 4326)",
    "'Fort Caroline National Memorial', ST_GeomFromText('POINT(-81.50042 30.38694)', 4326)",
    "'Fort Davis National Historic Site', ST_GeomFromText('POINT(-103.92562 30.59583)', 4326)",
    "'Fort Donelson National Battlefield', ST_GeomFromText('POINT(-87.85736 36.48438)', 4326)",
    "'Fort Donelson National Cemetery', ST_GeomFromText('POINT(-87.84766 36.48525)', 4326)",
    "'Fort Dupont Park', ST_GeomFromText('POINT(-76.94947 38.8766)', 4326)",
    "'Fort Foote Park', ST_GeomFromText('POINT(-77.02778 38.7667)', 4326)",
    "'Fort Frederica National Monument', ST_GeomFromText('POINT(-81.39313 31.22389)', 4326)",
    "'Fort Laramie National Historic Site', ST_GeomFromText('POINT(-104.53562 42.20917)', 4326)",
    "'Fort Larned National Historic Site', ST_GeomFromText('POINT(-99.2265 38.15667)', 4326)",
    "'Fort Matanzas National Monument', ST_GeomFromText('POINT(-81.23898 29.71528)', 4326)",
    "'Fort McHenry National Monument and Historic Shrine', ST_GeomFromText('POINT(-76.57981 39.26306)', 4326)",
    "'Fort Necessity National Battlefield', ST_GeomFromText('POINT(-79.59956 39.81667)', 4326)",
    "'Fort Point National Historic Site', ST_GeomFromText('POINT(-122.47692 37.81056)', 4326)",
    "'Fort Pulaski National Monument', ST_GeomFromText('POINT(-80.89008 32.02722)', 4326)",
    "'Fort Raleigh National Historic Site', ST_GeomFromText('POINT(-75.70872 35.93833)', 4326)",
    "'Fort Scott National Historic Site', ST_GeomFromText('POINT(-94.70455 37.84389)', 4326)",
    "'Fort Smith National Historic Site', ST_GeomFromText('POINT(-94.42261 35.34333)', 4326)",
    "'Fort Stanwix National Monument', ST_GeomFromText('POINT(-75.45506 43.21056)', 4326)",
    "'Fort Sumter National Monument', ST_GeomFromText('POINT(-79.87453 32.75222)', 4326)",
    "'Fort Union National Monument', ST_GeomFromText('POINT(-105.01802 35.90722)', 4326)",
    "'Fort Union Trading Post National Historic Site', ST_GeomFromText('POINT(-104.04032 47.99944)', 4326)",
    "'Fort Vancouver National Historic Site', ST_GeomFromText('POINT(-122.65792 45.6254)', 4326)",
    "'Fort Washington National Park', ST_GeomFromText('POINT(-77.03304 38.71083)', 4326)",
    "'Fossil Butte National Monument', ST_GeomFromText('POINT(-110.76762 41.85875)', 4326)",
    "'Franklin Delano Roosevelt Memorial', ST_GeomFromText('POINT(-77.0443 38.88389)', 4326)",
    "'Frederick Douglass National Historic Site', ST_GeomFromText('POINT(-76.98511 38.86333)', 4326)",
    "'Frederick Law Olmsted National Historic Site', ST_GeomFromText('POINT(-71.13205 42.325)', 4326)",
    "'Fredericksburg and Spotsylvania National Military Park', ST_GeomFromText('POINT(-77.46901 38.29305)', 4326)",
    "'Fredericksburg National Cemetery', ST_GeomFromText('POINT(-77.46884 38.29307)', 4326)",
    "'Friendship Hill National Historic Site', ST_GeomFromText('POINT(-79.92899 39.77778)', 4326)",
    "'Fundy National Park', ST_GeomFromText('POINT(-64.9536 45.59527)', 4326)",
    "'Gates of the Arctic National Park and Preserve', ST_GeomFromText('POINT(-153.29972 67.78333)', 4326)",
    "'Gateway National Recreation Area - Breezy Point', ST_GeomFromText('POINT(-73.92607 40.5565)', 4326)",
    "'Gateway National Recreation Area - Floyd Bennett Field', ST_GeomFromText('POINT(-73.89082 40.591)', 4326)",
    "'Gateway National Recreation Area - Fort Hancock', ST_GeomFromText('POINT(-74.00259 40.46389)', 4326)",
    "'Gateway National Recreation Area - Fort Tilden', ST_GeomFromText('POINT(-73.89093 40.56389)', 4326)",
    "'Gateway National Recreation Area - Fort Wadsworth', ST_GeomFromText('POINT(-74.06232 40.60833)', 4326)",
    "'Gateway National Recreation Area - Great Kills Park', ST_GeomFromText('POINT(-74.12715 40.55542)', 4326)",
    "'Gateway National Recreation Area - Jacob Riis Park', ST_GeomFromText('POINT(-73.87395 40.56702)', 4326)",
    "'Gateway National Recreation Area - Jamaica Bay', ST_GeomFromText('POINT(-73.84231 40.61778)', 4326)",
    "'Gateway National Recreation Area - Miller Field', ST_GeomFromText('POINT(-74.09538 40.56416)', 4326)",
    "'Gateway National Recreation Area - Sandy Hook', ST_GeomFromText('POINT(-73.99506 40.45288)', 4326)",
    "'Gauley River National Recreation Area', ST_GeomFromText('POINT(-80.88982 38.22)', 4326)",
    "'General Grant National Memorial', ST_GeomFromText('POINT(-73.96285 40.81333)', 4326)",
    "'George Mason Memorial', ST_GeomFromText('POINT(-77.03903 38.87944)', 4326)",
    "'George Rogers Clark National Historical Park', ST_GeomFromText('POINT(-87.5354 38.67919)', 4326)",
    "'George Washington Birthplace National Monument', ST_GeomFromText('POINT(-76.93036 38.18611)', 4326)",
    "'George Washington Carver National Monument', ST_GeomFromText('POINT(-94.354 36.98636)', 4326)",
    "'George Washington Memorial Parkway', ST_GeomFromText('POINT(-77.10217 38.91111)', 4326)",
    "'Georgian Bay Islands National Park', ST_GeomFromText('POINT(-79.87444 44.87777)', 4326)",
    "'Gettysburg National Cemetery', ST_GeomFromText('POINT(-77.23124 39.82027)', 4326)",
    "'Gettysburg National Military Park', ST_GeomFromText('POINT(-77.24615 39.81206)', 4326)",
    "'Giant Sequoia National Monument', ST_GeomFromText('POINT(-118.50438 36.04)', 4326)",
    "'Gila Cliff Dwellings National Monument', ST_GeomFromText('POINT(-108.27192 33.22722)', 4326)",
    "'Glacier Bay National Park', ST_GeomFromText('POINT(-135.75552 58.41543)', 4326)",
    "'Glacier Bay National Park and Preserve', ST_GeomFromText('POINT(-136.99996 58.5)', 4326)",
    "'Glacier National Park', ST_GeomFromText('POINT(-113.77572 48.692)', 4326)",
    "'Glen Canyon National Recreation Area', ST_GeomFromText('POINT(-111.48672 36.9936)', 4326)",
    "'Gloria Dei (Old Swedes'') Church', ST_GeomFromText('POINT(-75.14342 39.93444)', 4326)",
    "'Golden Gate National Recreation Area', ST_GeomFromText('POINT(-122.46652 37.78333)', 4326)",
    "'Golden Gate National Recreation Area-Alcatraz Island', ST_GeomFromText('POINT(-122.42322 37.82667)', 4326)",
    "'Golden Gate National Recreation Area-Presidio', ST_GeomFromText('POINT(-122.46572 37.79806)', 4326)",
    "'Golden Spike National Historic Site', ST_GeomFromText('POINT(-112.54722 41.62048)', 4326)",
    "'Governors Island National Monument', ST_GeomFromText('POINT(-74.01589 40.69139)', 4326)",
    "'Grand Canyon', ST_GeomFromText('POINT(-112.13722 36.05749)', 4326)",
    "'Grand Canyon - North Rim', ST_GeomFromText('POINT(-113.19712 36)', 4326)",
    "'Grand Canyon - South Rim National Park', ST_GeomFromText('POINT(-112.11732 36.06501)', 4326)",
    "'Grand Canyon National Park', ST_GeomFromText('POINT(-112.13745 36.0575)', 4326)",
    "'Grand Canyon West Airport', ST_GeomFromText('POINT(-113.81612 35.99038)', 4326)",
    "'Grand Canyon-Parashant National Monument', ST_GeomFromText('POINT(-113.69972 36.4)', 4326)",
    "'Grand Portage National Monument', ST_GeomFromText('POINT(-89.74898 47.98528)', 4326)",
    "'Grand Staircase-Escalante National Monument', ST_GeomFromText('POINT(-111.68327 37.4)', 4326)",
    "'Grand Teton National Park', ST_GeomFromText('POINT(-110.78822 43.7403)', 4326)",
    "'Grant-Kohrs Ranch National Historic Site', ST_GeomFromText('POINT(-112.73922 46.40833)', 4326)",
    "'Grasslands National Park', ST_GeomFromText('POINT(-107.42542 49.17694)', 4326)",
    "'Great Basin National Park', ST_GeomFromText('POINT(-114.26082 38.93873)', 4326)",
    "'Great Egg Harbor Scenic and Recreational River', ST_GeomFromText('POINT(-74.64957 39.30417)', 4326)",
    "'Great Sand Dunes National Park', ST_GeomFromText('POINT(-105.54172 37.7539)', 4326)",
    "'Great Sand Dunes National Park and Preserve', ST_GeomFromText('POINT(-105.51182 37.73287)', 4326)",
    "'Great Smoky Mountains National Park', ST_GeomFromText('POINT(-83.16773 35.72715)', 4326)",
    "'Greenbelt Park', ST_GeomFromText('POINT(-76.89831 38.98917)', 4326)",
    "'Gros Morne National Park', ST_GeomFromText('POINT(-57.78305 49.5)', 4326)",
    "'Guadalupe Mountains National Park', ST_GeomFromText('POINT(-104.85962 31.916)', 4326)",
    "'Guilford Courthouse National Military Park', ST_GeomFromText('POINT(-79.84623 36.13139)', 4326)",
    "'Gulf Islands National Park Reserve', ST_GeomFromText('POINT(-123.44732 48.85055)', 4326)",
    "'Gulf Islands National Seashore', ST_GeomFromText('POINT(-86.96735 30.36444)', 4326)",
    "'Gwaii Haanas Park Reserve and Haida Heritage Site', ST_GeomFromText('POINT(-131.47072 52.38916)', 4326)",
    "'Hagerman Fossil Beds National Monument', ST_GeomFromText('POINT(-114.94502 42.79028)', 4326)",
    "'Haleakala National Park', ST_GeomFromText('POINT(-156.21002 20.71062)', 4326)",
    "'Hamilton Grange National Memorial', ST_GeomFromText('POINT(-73.94815 40.82238)', 4326)",
    "'Hampton National Historic Site', ST_GeomFromText('POINT(-76.58734 39.41611)', 4326)",
    "'Hanford Reach National Monument', ST_GeomFromText('POINT(-119.51661 46.58333)', 4326)",
    "'Harmony Hall Fort Washington Maryland', ST_GeomFromText('POINT(-77.00304 38.74583)', 4326)",
    "'Harpers Ferry National Historical Park', ST_GeomFromText('POINT(-77.72952 39.32278)', 4326)",
    "'Harry S. Truman National Historic Site', ST_GeomFromText('POINT(-94.53209 38.90211)', 4326)",
    "'Hawaii Volcanoes National Park', ST_GeomFromText('POINT(-155.29962 19.39999)', 4326)",
    "'Herbert Hoover National Historic Site', ST_GeomFromText('POINT(-91.3479 41.66861)', 4326)",
    "'Historic Camden Revolutionary War Site', ST_GeomFromText('POINT(-80.60317 34.23389)', 4326)",
    "'Historic Jamestowne', ST_GeomFromText('POINT(-76.77873 37.20971)', 4326)",
    "'Hohokam Pima National Monument', ST_GeomFromText('POINT(-111.92642 33.15444)', 4326)",
    "'Home of Franklin D. Roosevelt National Historic Site', ST_GeomFromText('POINT(-73.93539 41.76721)', 4326)",
    "'Homestead National Monument of America', ST_GeomFromText('POINT(-96.82172 40.28525)', 4326)",
    "'Honokohau National Historical Park', ST_GeomFromText('POINT(-156.02172 19.6787)', 4326)",
    "'Hopewell Culture National Historical Park', ST_GeomFromText('POINT(-83.0062 39.37583)', 4326)",
    "'Hopewell Furnace National Historic Site', ST_GeomFromText('POINT(-75.7754 40.19861)', 4326)",
    "'Horseshoe Bend National Military Park', ST_GeomFromText('POINT(-85.73817 32.97083)', 4326)",
    "'Hot Springs National Park', ST_GeomFromText('POINT(-92.95843 34.52684)', 4326)",
    "'Hovenweep National Monument', ST_GeomFromText('POINT(-109.07702 37.38388)', 4326)",
    "'Hubbell Trading Post National Historic Site', ST_GeomFromText('POINT(-109.59312 35.72556)', 4326)",
    "'Independence Hall', ST_GeomFromText('POINT(-75.1498 39.94889)', 4326)",
    "'Independence National Historical Park', ST_GeomFromText('POINT(-75.14787 39.94778)', 4326)",
    "'Indiana Dunes National Lakeshore', ST_GeomFromText('POINT(-87.10791 41.64806)', 4326)",
    "'International Peace Garden', ST_GeomFromText('POINT(-100.06432 48.99098)', 4326)",
    "'Inupiat Heritage Center', ST_GeomFromText('POINT(-156.75331 71.29861)', 4326)",
    "'Ironwood Forest National Monument', ST_GeomFromText('POINT(-111.56673 32.45896)', 4326)",
    "'Isle Royale National Park', ST_GeomFromText('POINT(-88.89144 47.9624)', 4326)",
    "'Ivvavik National Park', ST_GeomFromText('POINT(-139.52462 69.51972)', 4326)",
    "'James A. Garfield National Historic Site', ST_GeomFromText('POINT(-81.34706 41.66222)', 4326)",
    "'Jasper National Park', ST_GeomFromText('POINT(-118.08182 52.87305)', 4326)",
    "'Jean Lafitte National Historical Park and Preserve', ST_GeomFromText('POINT(-89.99398 29.9425)', 4326)",
    "'Jefferson National Expansion Memorial', ST_GeomFromText('POINT(-90.18483 38.6246)', 4326)",
    "'Jewel Cave National Monument', ST_GeomFromText('POINT(-103.82912 43.72944)', 4326)",
    "'Jimmy Carter National Historic Site', ST_GeomFromText('POINT(-84.39984 32.03389)', 4326)",
    "'John D. Rockefeller Jr. Memorial Parkway', ST_GeomFromText('POINT(-110.69273 44.10472)', 4326)",
    "'John Day Fossil Beds National Monument', ST_GeomFromText('POINT(-119.63412 44.54987)', 4326)",
    "'John Ericsson National Memorial', ST_GeomFromText('POINT(-77.05014 38.88667)', 4326)",
    "'John Fitzgerald Kennedy National Historic Site', ST_GeomFromText('POINT(-71.12428 42.34583)', 4326)",
    "'John Muir National Historic Site', ST_GeomFromText('POINT(-122.13302 37.99131)', 4326)",
    "'Johnstown Flood National Memorial', ST_GeomFromText('POINT(-78.77847 40.34556)', 4326)",
    "'Joshua Tree National Park', ST_GeomFromText('POINT(-115.82762 33.843)', 4326)",
    "'Kalaupapa Leprosy Settlement and National Historical Park', ST_GeomFromText('POINT(-156.95972 21.17778)', 4326)",
    "'Kasha-Katuwe Tent Rocks National Monument', ST_GeomFromText('POINT(-106.41912 35.6736)', 4326)",
    "'Kate Mullany National Historic Site', ST_GeomFromText('POINT(-73.68163 42.7399)', 4326)",
    "'Katmai National Park', ST_GeomFromText('POINT(-154.88652 58.58305)', 4326)",
    "'Katmai National Park and Preserve', ST_GeomFromText('POINT(-154.99972 58.5)', 4326)",
    "'Kejimkujik National Park', ST_GeomFromText('POINT(-65.21805 44.39916)', 4326)",
    "'Kenai Fjords National Park', ST_GeomFromText('POINT(-149.64982 59.91666)', 4326)",
    "'Kenilworth Park and Aquatic Gardens', ST_GeomFromText('POINT(-76.94771 38.90833)', 4326)",
    "'Kennesaw Mountain National Battlefield Park', ST_GeomFromText('POINT(-84.5779 33.98306)', 4326)",
    "'Keweenaw National Historical Park', ST_GeomFromText('POINT(-88.4537 47.24667)', 4326)",
    "'Kings Canyon National Park', ST_GeomFromText('POINT(-118.64062 36.81199)', 4326)",
    "'Kings Mountain National Military Park', ST_GeomFromText('POINT(-81.38928 35.13778)', 4326)",
    "'Klondike Gold Rush National Historical Park', ST_GeomFromText('POINT(-135.31162 59.45639)', 4326)",
    "'Kluane National Park and Reserve', ST_GeomFromText('POINT(-137.50982 60.75305)', 4326)",
    "'Knife River Indian Villages National Historic Site', ST_GeomFromText('POINT(-101.38562 47.35417)', 4326)",
    "'Kobuk Valley National Park', ST_GeomFromText('POINT(-159.13662 67.34408)', 4326)",
    "'Kootenay National Park', ST_GeomFromText('POINT(-116.04872 50.88305)', 4326)",
    "'Korean War Veterans Memorial', ST_GeomFromText('POINT(-77.047 38.88778)', 4326)",
    "'Kouchibouguac National Park', ST_GeomFromText('POINT(-64.96666 46.84972)', 4326)",
    "'La Mauricie National Park', ST_GeomFromText('POINT(-72.85583 46.80805)', 4326)",
    "'Lake Chelan National Recreation Area', ST_GeomFromText('POINT(-120.67802 48.32194)', 4326)",
    "'Lake Clark National Park', ST_GeomFromText('POINT(-154.32362 60.19943)', 4326)",
    "'Lake Clark National Park and Preserve', ST_GeomFromText('POINT(-153.41642 60.96667)', 4326)",
    "'Lake Mead National Recreation Area', ST_GeomFromText('POINT(-113.69972 36.4)', 4326)",
    "'Lake Mead National Recreation Area', ST_GeomFromText('POINT(-114.79642 36.00972)', 4326)",
    "'Lake Meredith National Recreation Area', ST_GeomFromText('POINT(-101.55252 35.71472)', 4326)",
    "'Lake Roosevelt National Recreation Area', ST_GeomFromText('POINT(-118.98032 47.95611)', 4326)",
    "'Lassen Volcanic National Park', ST_GeomFromText('POINT(-121.41452 40.48297)', 4326)",
    "'Lava Beds National Monument', ST_GeomFromText('POINT(-121.50802 41.71389)', 4326)",
    "'Lewis and Clark National and State Historical Parks', ST_GeomFromText('POINT(-123.87722 46.13361)', 4326)",
    "'Lewis and Clark National Historic Trail', ST_GeomFromText('POINT(-108.00939 46.00361)', 4326)",
    "'Liberty Memorial', ST_GeomFromText('POINT(-94.58606 39.08044)', 4326)",
    "'Lincoln Boyhood National Memorial', ST_GeomFromText('POINT(-86.9968 38.11833)', 4326)",
    "'Lincoln Home National Historic Site', ST_GeomFromText('POINT(-89.64484 39.79722)', 4326)",
    "'Lincoln Memorial', ST_GeomFromText('POINT(-77.04992 38.8893)', 4326)",
    "'Little Bighorn Battlefield National Monument', ST_GeomFromText('POINT(-107.42722 45.57028)', 4326)",
    "'Little River Canyon National Preserve', ST_GeomFromText('POINT(-85.59536 34.44056)', 4326)",
    "'Little Rock Central High School National Historic Site', ST_GeomFromText('POINT(-92.29845 34.73666)', 4326)",
    "'Longfellow National Historic Site', ST_GeomFromText('POINT(-71.12623 42.37667)', 4326)",
    "'Lowell National Historical Park', ST_GeomFromText('POINT(-71.31008 42.64667)', 4326)",
    "'Lower East Side Tenement National Historic Site', ST_GeomFromText('POINT(-73.98997 40.7185)', 4326)",
    "'Lyndon B. Johnson National Historical Park', ST_GeomFromText('POINT(-98.62398 30.24083)', 4326)",
    "'Lyndon Baines Johnson Memorial Grove on the Potomac', ST_GeomFromText('POINT(-77.05125 38.87861)', 4326)",
    "'Maggie L. Walker National Historic Site', ST_GeomFromText('POINT(-77.4379 37.54778)', 4326)",
    "'Mammoth Cave National Park', ST_GeomFromText('POINT(-86.11403 37.1841)', 4326)",
    "'Manassas National Battlefield Park', ST_GeomFromText('POINT(-77.52151 38.81277)', 4326)",
    "'Manzanar National Historic Site', ST_GeomFromText('POINT(-118.15422 36.72833)', 4326)",
    "'Marianas Trench Marine National Monument', ST_GeomFromText('POINT(145 20)', 4326)",
    "'Marsh-Billings-Rockefeller National Historical Park', ST_GeomFromText('POINT(-72.52917 43.63125)', 4326)",
    "'Martin Luther King Jr National Memorial', ST_GeomFromText('POINT(-77.045124 38.885926)', 4326)",
    "'Martin Luther King Jr. National Historic Site', ST_GeomFromText('POINT(-84.37211 33.755)', 4326)",
    "'Martin Van Buren National Historic Site', ST_GeomFromText('POINT(-73.70405 42.36971)', 4326)",
    "'Mary McLeod Bethune Council House National Historic Site', ST_GeomFromText('POINT(-77.03012 38.90778)', 4326)",
    "'Meridian Hill Park', ST_GeomFromText('POINT(-77.03559 38.92124)', 4326)",
    "'Mesa Verde National Park', ST_GeomFromText('POINT(-108.50862 37.3192)', 4326)",
    "'Middle Delaware National Scenic River', ST_GeomFromText('POINT(-74.89984 41.15)', 4326)",
    "'Mingan Archipelago National Park Reserve', ST_GeomFromText('POINT(-63.57638 50.25472)', 4326)",
    "'Minidoka National Historic Site', ST_GeomFromText('POINT(-114.23202 42.63694)', 4326)",
    "'Minute Man National Historical Park', ST_GeomFromText('POINT(-71.29842 42.45306)', 4326)",
    "'Minuteman Missile National Historic Site', ST_GeomFromText('POINT(-102.16032 43.93111)', 4326)",
    "'Missouri National Recreational River', ST_GeomFromText('POINT(-97.39263 42.8625)', 4326)",
    "'Misty Fiords National Monument', ST_GeomFromText('POINT(-130.60716 55.62167)', 4326)",
    "'Mojave National Preserve', ST_GeomFromText('POINT(-115.71642 34.88333)', 4326)",
    "'Monocacy National Battlefield', ST_GeomFromText('POINT(-77.39192 39.37115)', 4326)",
    "'Montezuma Castle National Monument', ST_GeomFromText('POINT(-111.83972 34.61305)', 4326)",
    "'Moores Creek National Battlefield', ST_GeomFromText('POINT(-78.10928 34.45806)', 4326)",
    "'Morristown National Historical Park', ST_GeomFromText('POINT(-74.52842 40.76694)', 4326)",
    "'Mount Rainier National Park', ST_GeomFromText('POINT(-121.74982 46.85)', 4326)",
    "'Mount Revelstoke National Park', ST_GeomFromText('POINT(-118.06512 51.08583)', 4326)",
    "'Mount Rushmore National Memorial', ST_GeomFromText('POINT(-103.45952 43.87895)', 4326)",
    "'Mount St. Helens National Volcanic Monument', ST_GeomFromText('POINT(-122.18422 46.23317)', 4326)",
    "'Muir Woods National Monument', ST_GeomFromText('POINT(-122.58362 37.89889)', 4326)",
    "'Nahanni National Park Reserve', ST_GeomFromText('POINT(-123.59962 61.08333)', 4326)",
    "'Natchez National Historical Park', ST_GeomFromText('POINT(-91.38287 31.54333)', 4326)",
    "'Natchez Trace Trail', ST_GeomFromText('POINT(-88.08826 34.66772)', 4326)",
    "'National Constitution Center', ST_GeomFromText('POINT(-75.14876 39.95341)', 4326)",
    "'National Japanese Am. Memorial To Patriotism During WW II', ST_GeomFromText('POINT(-77.01034 38.89452)', 4326)",
    "'National Mall', ST_GeomFromText('POINT(-77.02339 38.89)', 4326)",
    "'National Park of American Samoa', ST_GeomFromText('POINT(-170.68512 -14.25708)', 4326)",
    "'National World War II Memorial', ST_GeomFromText('POINT(-77.04029 38.8894)', 4326)",
    "'Natural Bridges National Monument', ST_GeomFromText('POINT(-110.01342 37.60138)', 4326)",
    "'Navajo National Monument', ST_GeomFromText('POINT(-110.53442 36.68417)', 4326)",
    "'New Bedford Whaling National Historical Park', ST_GeomFromText('POINT(-70.92314 41.63556)', 4326)",
    "'New Jersey Pinelands National Reserve', ST_GeomFromText('POINT(-74.74985 39.75)', 4326)",
    "'New Orleans Jazz National Historical Park', ST_GeomFromText('POINT(-90.06784 29.96306)', 4326)",
    "'New River Gorge National River', ST_GeomFromText('POINT(-81.08152 37.96083)', 4326)",
    "'Newberry National Volcanic Monument', ST_GeomFromText('POINT(-121.25188 43.69417)', 4326)",
    "'Nez Perce National Historical Park', ST_GeomFromText('POINT(-116.35912 46.14194)', 4326)",
    "'Nicodemus National Historic Site', ST_GeomFromText('POINT(-99.61734 39.39083)', 4326)",
    "'Ninety Six National Historic Site', ST_GeomFromText('POINT(-82.02428 34.14694)', 4326)",
    "'Niobrara National Scenic River', ST_GeomFromText('POINT(-100.31642 42.88333)', 4326)",
    "'Noatak National Preserve', ST_GeomFromText('POINT(-161.19972 68)', 4326)",
    "'North Cascades National Park', ST_GeomFromText('POINT(-121.18952 48.70643)', 4326)",
    "'Ocmulgee National Monument', ST_GeomFromText('POINT(-83.60814 32.83667)', 4326)",
    "'Oklahoma City National Memorial', ST_GeomFromText('POINT(-97.51708 35.47278)', 4326)",
    "'Old Post Office Pavilion', ST_GeomFromText('POINT(-77.02788 38.89398)', 4326)",
    "'Old Stone House', ST_GeomFromText('POINT(-77.06054 38.90556)', 4326)",
    "'Olympic National Park', ST_GeomFromText('POINT(-123.52162 47.799)', 4326)",
    "'Oregon Caves National Monument', ST_GeomFromText('POINT(-123.40692 42.09806)', 4326)",
    "'Organ Pipe Cactus National Park', ST_GeomFromText('POINT(-112.85752 32.04444)', 4326)",
    "'Oxon Cove Park and Oxon Hill Farm', ST_GeomFromText('POINT(-78.31665 37.08806)', 4326)",
    "'Ozark National Scenic Riverways', ST_GeomFromText('POINT(-91.27615 37.1907)', 4326)",
    "'Pacific Rim National Park Reserve', ST_GeomFromText('POINT(-124.76872 48.63611)', 4326)",
    "'Padre Island National Seashore', ST_GeomFromText('POINT(-97.36846 26.98444)', 4326)",
    "'Palo Alto Battlefield National Historical Park', ST_GeomFromText('POINT(-97.48037 26.02139)', 4326)",
    "'Papah?naumoku?kea Marine National Monument', ST_GeomFromText('POINT(-171.73327 25.7)', 4326)",
    "'Pea Ridge National Military Park', ST_GeomFromText('POINT(-94.03401 36.45444)', 4326)",
    "'Pecos National Historical Park', ST_GeomFromText('POINT(-105.68912 35.54999)', 4326)",
    "'Peirce Mill', ST_GeomFromText('POINT(-77.05192 38.94028)', 4326)",
    "'Pennsylvania Avenue National Historic Site', ST_GeomFromText('POINT(-77.02373 38.89361)', 4326)",
    "'Perry''s Victory and International Peace Memorial', ST_GeomFromText('POINT(-82.81124 41.65417)', 4326)",
    "'Petersburg National Battlefield', ST_GeomFromText('POINT(-77.36123 37.21944)', 4326)",
    "'Petrified Forest National Park', ST_GeomFromText('POINT(-109.78332 35.06274)', 4326)",
    "'Petroglyph National Monument', ST_GeomFromText('POINT(-106.76162 35.13583)', 4326)",
    "'Pictured Rocks National Lakeshore', ST_GeomFromText('POINT(-86.31235 46.56222)', 4326)",
    "'Pinnacles National Monument', ST_GeomFromText('POINT(-121.16662 36.48693)', 4326)",
    "'Pipe Spring National Monument', ST_GeomFromText('POINT(-112.73692 36.86193)', 4326)",
    "'Pipestone National Monument', ST_GeomFromText('POINT(-96.32481 44.01333)', 4326)",
    "'Piscataway Park', ST_GeomFromText('POINT(-77.09276 38.67861)', 4326)",
    "'Point Pelee National Park', ST_GeomFromText('POINT(-82.51749 41.96416)', 4326)",
    "'Point Reyes National Seashore', ST_GeomFromText('POINT(-122.88502 38.06)', 4326)",
    "'Pompeys Pillar National Monument', ST_GeomFromText('POINT(-108.00577 45.99528)', 4326)",
    "'Poplar Grove National Cemetery', ST_GeomFromText('POINT(-77.42845 37.16028)', 4326)",
    "'Port Chicago Naval Magazine National Memorial', ST_GeomFromText('POINT(-122.02952 38.05749)', 4326)",
    "'Poverty Point National Monument', ST_GeomFromText('POINT(-91.40763 32.63904)', 4326)",
    "'Prehistoric Trackways National Monument', ST_GeomFromText('POINT(-106.89972 32.35)', 4326)",
    "'President Lincoln''s Cottage at the Soldiers'' Home', ST_GeomFromText('POINT(-77.01161 38.94167)', 4326)",
    "'President''s Park (White House)', ST_GeomFromText('POINT(-77.03674 38.89417)', 4326)",
    "'Prince Albert National Park', ST_GeomFromText('POINT(-106.23322 53.99583)', 4326)",
    "'Prince Edward Island National Park', ST_GeomFromText('POINT(-63.07472 46.41666)', 4326)",
    "'Prince William Forest Park', ST_GeomFromText('POINT(-77.3797 38.58528)', 4326)",
    "'Pu''uhonua o Honaunau National Historical Park', ST_GeomFromText('POINT(-155.91002 19.42194)', 4326)",
    "'Pu''ukohola Heiau National Historic Site', ST_GeomFromText('POINT(-155.81972 20.02667)', 4326)",
    "'Pukaskwa National Park', ST_GeomFromText('POINT(-85.9161 48.03361)', 4326)",
    "'Quttinirpaaq National Park', ST_GeomFromText('POINT(-68.4211 81.56388)', 4326)",
    "'Rainbow Bridge National Monument', ST_GeomFromText('POINT(-110.96382 37.07721)', 4326)",
    "'Red Hill Patrick Henry National Memorial', ST_GeomFromText('POINT(-78.89792 37.03222)', 4326)",
    "'Redwood National Park', ST_GeomFromText('POINT(-123.94482 41.4771)', 4326)",
    "'Richmond National Battlefield Park', ST_GeomFromText('POINT(-77.37345 37.42917)', 4326)",
    "'Riding Mountain National Park', ST_GeomFromText('POINT(-100.03572 50.86388)', 4326)",
    "'River Raisin National Battlefield Park', ST_GeomFromText('POINT(-83.37817 41.91361)', 4326)",
    "'Rock Creek and Potomac Parkway', ST_GeomFromText('POINT(-77.05439 38.91306)', 4326)",
    "'Rock Creek Park', ST_GeomFromText('POINT(-77.04498 38.9575)', 4326)",
    "'Rocky Mountain National Park', ST_GeomFromText('POINT(-105.68962 40.414)', 4326)",
    "'Roger Williams National Memorial', ST_GeomFromText('POINT(-71.41075 41.83038)', 4326)",
    "'Roosevelt Campobello International Park', ST_GeomFromText('POINT(-66.95915 44.87583)', 4326)",
    "'Rose Atoll Marine National Monument', ST_GeomFromText('POINT(-168.14994 -14.50994)', 4326)",
    "'Ross Lake National Recreation Area', ST_GeomFromText('POINT(-121.24502 48.67306)', 4326)",
    "'Russell Cave National Monument', ST_GeomFromText('POINT(-85.80314 34.97417)', 4326)",
    "'Sagamore Hill National Historic Site', ST_GeomFromText('POINT(-73.49734 40.88556)', 4326)",
    "'Saguaro National Park', ST_GeomFromText('POINT(-111.13052 32.2432)', 4326)",
    "'Saint Croix Island International Historic Site', ST_GeomFromText('POINT(-67.13317 45.12833)', 4326)",
    "'Saint Croix National Scenic Riverway', ST_GeomFromText('POINT(-92.65735 45.38917)', 4326)",
    "'Saint Paul''s Church National Historic Site', ST_GeomFromText('POINT(-73.82566 40.89278)', 4326)",
    "'Saint-Gaudens National Historic Site', ST_GeomFromText('POINT(-72.36848 43.4959)', 4326)",
    "'Salem Maritime National Historic Site', ST_GeomFromText('POINT(-70.88706 42.52056)', 4326)",
    "'Salinas Pueblo Missions National Monument', ST_GeomFromText('POINT(-106.09002 34.25972)', 4326)",
    "'Salt River Bay National Historical Park', ST_GeomFromText('POINT(-64.7587 17.77889)', 4326)",
    "'San Antonio Missions National Historical Park', ST_GeomFromText('POINT(-98.48008 29.36167)', 4326)",
    "'San Francisco Maritime National Historical Park', ST_GeomFromText('POINT(-122.42332 37.80639)', 4326)",
    "'San Juan Island National Historical Park', ST_GeomFromText('POINT(-122.98532 48.45583)', 4326)",
    "'San Juan National Historic Site', ST_GeomFromText('POINT(-66.11012 18.4675)', 4326)",
    "'Sand Creek Massacre National Historic Site', ST_GeomFromText('POINT(-102.52832 38.54083)', 4326)",
    "'Santa Monica Mountains National Recreation Area', ST_GeomFromText('POINT(-118.60222 34.10389)', 4326)",
    "'Santa Rosa and San Jacinto Mountains National Monument', ST_GeomFromText('POINT(-116.7055 33.80083)', 4326)",
    "'Saratoga National Historical Park', ST_GeomFromText('POINT(-73.63728 42.99889)', 4326)",
    "'Saugus Iron Works National Historic Site', ST_GeomFromText('POINT(-71.00873 42.46778)', 4326)",
    "'Scotts Bluff National Monument', ST_GeomFromText('POINT(-103.70052 41.83556)', 4326)",
    "'Sequoia National Park', ST_GeomFromText('POINT(-118.72242 36.36444)', 4326)",
    "'Sewall-Belmont House National Historic Site', ST_GeomFromText('POINT(-77.00344 38.89194)', 4326)",
    "'Shenandoah National Park', ST_GeomFromText('POINT(-78.30072 38.72)', 4326)",
    "'Shiloh National Cemetery', ST_GeomFromText('POINT(-88.32007 35.15041)', 4326)",
    "'Shiloh National Military Park', ST_GeomFromText('POINT(-88.32981 35.15188)', 4326)",
    "'Sirmilik National Park', ST_GeomFromText('POINT(-78.43416 72.34054)', 4326)",
    "'Sitka National Historical Park', ST_GeomFromText('POINT(-135.31362 57.04694)', 4326)",
    "'Sleeping Bear Dunes National Lakeshore', ST_GeomFromText('POINT(-86.02013 44.91306)', 4326)",
    "'Sonoran Desert National Monument', ST_GeomFromText('POINT(-112.45494 33.00167)', 4326)",
    "'Springfield Armory National Historic Site', ST_GeomFromText('POINT(-72.58151 42.10806)', 4326)",
    "'St. Lawrence Islands National Park', ST_GeomFromText('POINT(-75.87276 44.41444)', 4326)",
    "'Star-Spangled Banner National Historic Trail', ST_GeomFromText('POINT(-76.57995 39.26306)', 4326)",
    "'Statue Of Liberty National Monument', ST_GeomFromText('POINT(-74.04477 40.68968)', 4326)",
    "'Steamtown National Historic Site', ST_GeomFromText('POINT(-75.67116 41.40733)', 4326)",
    "'Stones River National Battlefield', ST_GeomFromText('POINT(-86.43639 35.87629)', 4326)",
    "'Stones River National Cemetery', ST_GeomFromText('POINT(-86.436 35.87639)', 4326)",
    "'Suitland Parkway', ST_GeomFromText('POINT(-76.96801 38.84694)', 4326)",
    "'Sunset Crater Volcano National Monument', ST_GeomFromText('POINT(-111.50042 35.36558)', 4326)",
    "'Tallgrass Prairie National Preserve', ST_GeomFromText('POINT(-96.55869 38.43278)', 4326)",
    "'Terra Nova National Park', ST_GeomFromText('POINT(-53.99583 48.51194)', 4326)",
    "'Thaddeus Kosciuszko National Memorial', ST_GeomFromText('POINT(-75.14732 39.94333)', 4326)",
    "'Theodore Roosevelt Birthplace National Historic Site', ST_GeomFromText('POINT(-73.98956 40.73889)', 4326)",
    "'Theodore Roosevelt Inaugural National Historic Site', ST_GeomFromText('POINT(-78.87226 42.90148)', 4326)",
    "'Theodore Roosevelt Island', ST_GeomFromText('POINT(-77.06402 38.89721)', 4326)",
    "'Theodore Roosevelt National Park', ST_GeomFromText('POINT(-103.24872 47.3352)', 4326)",
    "'Thomas Cole National Historic Site', ST_GeomFromText('POINT(-73.86178 42.22583)', 4326)",
    "'Thomas Edison National Historical Park', ST_GeomFromText('POINT(-74.23759 40.78694)', 4326)",
    "'Thomas Jefferson Memorial', ST_GeomFromText('POINT(-77.03647 38.88139)', 4326)",
    "'Thomas Stone National Historic Site', ST_GeomFromText('POINT(-77.03595 38.53139)', 4326)",
    "'Timpanogos Cave National Monument', ST_GeomFromText('POINT(-111.70912 40.44056)', 4326)",
    "'Tomb of the Unknowns', ST_GeomFromText('POINT(-77.07206 38.87638)', 4326)",
    "'Tonto National Monument', ST_GeomFromText('POINT(-111.09412 33.65694)', 4326)",
    "'Torngat Mountains National Park Reserve', ST_GeomFromText('POINT(-63.10027 58.67222)', 4326)",
    "'Touro Synagogue National Historic Site', ST_GeomFromText('POINT(-71.31178 41.48944)', 4326)",
    "'Tuktut Nogait National Park', ST_GeomFromText('POINT(-123.01622 69.28333)', 4326)",
    "'Tumac-cori National Historical Park', ST_GeomFromText('POINT(-111.05052 31.5675)', 4326)",
    "'Tupelo National Battlefield', ST_GeomFromText('POINT(-88.73706 34.25528)', 4326)",
    "'Tuskegee Airmen National Historic Site', ST_GeomFromText('POINT(-85.67984 32.45722)', 4326)",
    "'Tuskegee Institute National Historic Site', ST_GeomFromText('POINT(-85.70762 32.43028)', 4326)",
    "'Tuzigoot National Monument', ST_GeomFromText('POINT(-112.02572 34.77085)', 4326)",
    "'U.S. Air Force Memorial', ST_GeomFromText('POINT(-77.06606 38.86865)', 4326)",
    "'Ukkusiksalik National Park', ST_GeomFromText('POINT(-87.30527 65.34166)', 4326)",
    "'Ulysses S. Grant National Historic Site', ST_GeomFromText('POINT(-90.35178 38.55111)', 4326)",
    "'United States Marine Corps War Memorial', ST_GeomFromText('POINT(-77.06946 38.89047)', 4326)",
    "'United States Navy Memorial', ST_GeomFromText('POINT(-77.02286 38.89417)', 4326)",
    "'Upper Missouri River Breaks National Monument', ST_GeomFromText('POINT(-109.02133 47.78333)', 4326)",
    "'USS Arizona Memorial', ST_GeomFromText('POINT(-157.94972 21.365)', 4326)",
    "'USS Utah Memorial', ST_GeomFromText('POINT(-157.96244 21.36889)', 4326)",
    "'Valley Forge National Historical Park', ST_GeomFromText('POINT(-75.43869 40.09693)', 4326)",
    "'Vanderbilt Mansion National Historic Site', ST_GeomFromText('POINT(-73.94174 41.79611)', 4326)",
    "'Vermilion Cliffs National Monument', ST_GeomFromText('POINT(-111.74105 36.80639)', 4326)",
    "'Vicksburg National Cemetery', ST_GeomFromText('POINT(-90.84959 32.34886)', 4326)",
    "'Vicksburg National Military Park', ST_GeomFromText('POINT(-90.84963 32.34879)', 4326)",
    "'Vietnam Veterans Memorial', ST_GeomFromText('POINT(-77.04756 38.8911)', 4326)",
    "'Vietnam Women''s Memorial', ST_GeomFromText('POINT(-77.04679 38.8904)', 4326)",
    "'Virgin Islands Coral Reef National Monument', ST_GeomFromText('POINT(-64.72675 18.30611)', 4326)",
    "'Virgin Islands National Park', ST_GeomFromText('POINT(-64.73323 18.33333)', 4326)",
    "'Voyageurs National Park', ST_GeomFromText('POINT(-93.01663 48.0996)', 4326)",
    "'Vuntut National Park', ST_GeomFromText('POINT(-140.04712 68.30694)', 4326)",
    "'Walnut Canyon National Monument', ST_GeomFromText('POINT(-111.50942 35.17167)', 4326)",
    "'Wapusk National Park', ST_GeomFromText('POINT(-92.66999 57.24638)', 4326)",
    "'War in the Pacific National Historical Park', ST_GeomFromText('POINT(144.66694 13.3)', 4326)",
    "'Washington Monument', ST_GeomFromText('POINT(-77.03504 38.88947)', 4326)",
    "'Washita Battlefield National Historic Site', ST_GeomFromText('POINT(-99.70012 36.6175)', 4326)",
    "'Waterton Lakes National Park', ST_GeomFromText('POINT(-113.91482 49.04583)', 4326)",
    "'Weir Farm National Historic Site', ST_GeomFromText('POINT(-73.45455 41.25806)', 4326)",
    "'West Potomac Park', ST_GeomFromText('POINT(-77.0469 38.886)', 4326)",
    "'Whiskeytown-Shasta-Trinity National Recreation Area', ST_GeomFromText('POINT(-122.94172 40.73528)', 4326)",
    "'White House', ST_GeomFromText('POINT(-77.03634 38.89767)', 4326)",
    "'White Sands National Monument', ST_GeomFromText('POINT(-106.17142 32.77971)', 4326)",
    "'Whitman Mission National Historic Site', ST_GeomFromText('POINT(-118.46112 46.04)', 4326)",
    "'William Howard Taft National Historic Site', ST_GeomFromText('POINT(-84.50845 39.11972)', 4326)",
    "'William J Clinton Birthplace Home National Historic Site', ST_GeomFromText('POINT(-93.5964 33.66717)', 4326)",
    "'Wilson''s Creek National Battlefield', ST_GeomFromText('POINT(-93.41984 37.11556)', 4326)",
    "'Wind Cave National Park', ST_GeomFromText('POINT(-103.43302 43.5909)', 4326)",
    "'Wolf Trap National Park for the Performing Arts', ST_GeomFromText('POINT(-77.26184 38.93694)', 4326)",
    "'Women''s Rights National Historical Park', ST_GeomFromText('POINT(-76.8012 42.91083)', 4326)",
    "'Wood Buffalo National Park', ST_GeomFromText('POINT(-112.98592 59.39083)', 4326)",
    "'World War II Home Front National Historical Park', ST_GeomFromText('POINT(-122.36442 37.90619)', 4326)",
    "'Wrangell-St. Elias National Park', ST_GeomFromText('POINT(-143.21622 61.24284)', 4326)",
    "'Wrangell-St. Elias National Park and Preserve', ST_GeomFromText('POINT(-141.99972 61)', 4326)",
    "'Wright Brothers National Memorial', ST_GeomFromText('POINT(-75.66792 36.01417)', 4326)",
    "'Wupatki National Monument', ST_GeomFromText('POINT(-111.38662 35.56556)', 4326)",
    "'WW II Valor in the Pacific National Monument Atka Island', ST_GeomFromText('POINT(-174.44522 52.13806)', 4326)",
    "'WW II Valor in the Pacific National Monument Attu Island', ST_GeomFromText('POINT(172.90944 52.9025)', 4326)",
    "'WW II Valor in the Pacific National Monument Ford Island', ST_GeomFromText('POINT(-157.96022 21.36389)', 4326)",
    "'WW II Valor in the Pacific National Monument Kiska', ST_GeomFromText('POINT(177.46 51.96417)', 4326)",
    "'WW II Valor in the Pacific Tule Lake Relocation Center', ST_GeomFromText('POINT(-121.37466 41.88944)', 4326)",
    "'Yellowstone National Park', ST_GeomFromText('POINT(-110.61342 44.79573)', 4326)",
    "'Yoho National Park', ST_GeomFromText('POINT(-116.48622 51.39527)', 4326)",
    "'Yorktown National Cemetery', ST_GeomFromText('POINT(-76.50624 37.22493)', 4326)",
    "'Yosemite National Park', ST_GeomFromText('POINT(-119.69432 37.6379)', 4326)",
    "'Yucca House National Monument', ST_GeomFromText('POINT(-108.68612 37.25027)', 4326)",
    "'Yukon-Charley Rivers National Preserve', ST_GeomFromText('POINT(-142.79972 65)', 4326)",
    "'Zion National Park', ST_GeomFromText('POINT(-112.68142 37.22299)', 4326)"
]

if __name__ == '__main__':
    bootstrap()
